ClassSectionMeetingDate

EntityType | Independent
Logical Entity Name | ClassSectionMeetingDate
Default Table Name | AdClassAttend
Logical Only | NO
Owner | dbo
Definition |
Note |

ClassSectionMeetingDate Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
ClassSectionId |  | INTEGER | YES |
ClassSectionMeetingDateId |  | INTEGER | NO |
MeetingDate |  | DATETIME | NO |
StartTime |  | DATETIME | NO |
LengthMinutes |  | NUMERIC(5, 0) | NO |
RoomId |  | INTEGER | NO |
InstructorId |  | INTEGER | NO |
Status |  | CHAR(1) | NO |
Note |  | VARCHAR(128) | YES |
IsManualEdit |  | BIT | NO |
LastModifiedUserId |  | INTEGER | NO |
CreatedDateTime |  | DATETIME | NO |
LastModifiedDateTime |  | DATETIME | NO |
ModFlag |  | CHAR(1) | YES |
RowVersion |  | TIMESTAMP/DATE | NO |
ClassSectionMeetingPatternId |  | INTEGER | YES |
IsMeetingEdit |  | BIT | NO |

ClassSectionMeetingDate Keys

Key Name | Key Type | Keys
AdClassAttend_AdClassSchedPeriodID_N_N_IDX | Inversion Entry | ClassSectionMeetingPatternId
AdClassAttend_AdTeacherID_N_N_IDX | Inversion Entry | InstructorId
NK_AdClassAttend_AdClassSchedPeriodID_Status_INCL | Inversion Entry | ClassSectionMeetingPatternId, Status
AdClassAttend_AdRoomID_N_N_IDX | Inversion Entry | RoomId
AdClassAttend_AdClassSchedID_Status_N_N_IDX | Inversion Entry | ClassSectionId, Status
AdClassAttend_AdClassSchedID_N_N_IDX | Inversion Entry | ClassSectionId
AdClassAttend_AdClassSchedID_Date_N_N_IDX | Inversion Entry | ClassSectionId, MeetingDate
AdClassAttend_AdClassAttendID_U_C_IDX | PrimaryKey | ClassSectionMeetingDateId

ClassSectionMeetingDate Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
ClassSection | Non-Identifying | Zero or One to Zero or More |  |  |  | ClassSectionId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype
Instructor | Non-Identifying | One To Zero or More |  |  |  |  | NO
Room | Non-Identifying | One To Zero or More |  |  |  |  | NO
AdClassSchedPeriodInstructor | Non-Identifying | One To Zero or More |  |  |  |  | NO
AdClassSchedPeriodLoadTypeAssociation | Non-Identifying | One To Zero or More |  |  |  |  | NO

ClassSectionMeetingDate Check Constraints

Check Constraint Name | CheckConstraint

ClassSectionMeetingDate Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.ClassSectionMeetingDate | NO |  |  |
Physical (Microsoft SQL Server) dbo.AdClassAttend | NO |  |  |

ClassSectionMeetingDate Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | ClassScheduling
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Academic Records

ClassSectionMeetingDate Data Movement Rules

Name | Type | Rule Text/Value